Improving grouping, sorting, and totaling
Performing grouping on server
If you're reporting in real-time off live data over the Web, reduce the amount of data transferred from the database server by using the Perform Grouping on Server option. With this option, much data processing is off-loaded to the database server and only a subset of data is read initially. Detail data is returned from the database only when you drill down in a report.
Note: Server-side processing works only for sorted and grouped reports that are based on SQL data sources.
To enable server-side processing
- On the File menu, click Report Options.
- Select Perform Grouping on Server on the Report Options dialog box.
This check box is inactive if Use Indexes or Server for Speed is not selected.
Tip: When Use Indexes or Server for Speed is selected, you can quickly enable Perform Grouping On Server from the Database menu.
- Click OK.
To see how grouping on the server can affect performance, go to Benefits of grouping on serveran example.
Related topics